Album Name checks against Japanese, transliterated, or translated names. % is the wildcard, so a search for %love% will find albums that used love or words that translated to love.

Credits: Probably quicker to show a few examples than try to explain it in full. != is the way to express "not".
[Artist=Minimoni]
[Artist=%Musume%] and [Artist!=Coconuts Musume]
[Producer!=Tsunku]

Release Date: Use YYYY-MM-DD date format.

Order By: Usually just clicking on the column headers will be fine, but you can also combine them here, like
AlbumType ASC, Seniority ASC
Artist ASC, AlbumType DESC